Work in progress: performance regression tracking

Note:

Solution

data.table

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.5 3.5 -3% 3.3 -5%
2 4.3 3.5 23% 3.5 16%
3 5.4 4.8 11% 4.5 14%
4 6.1 6.1 2% 5.6 10%
5 5.9 5.5 9% 4.9 11%
6 47.2 47.9 -2%
7 128.6 106.7 17%
8 167.6 146.9 11%
9 16.0 14.7 9% 43.9 -46%
10 67.2 68.1 1% 93.7 -12%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.1 1.1 6%
1e8 11.1 9.9 9%
1e9 123.3 111.3 8%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 45.2 40.8 8%
1e1
2e0 158.3 141.9 3%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 45.2 40.8 8%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 45.2 40.8 8%
1 43.1 36.2 18%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.2 -33% 0.2 -32%
1 1e8 1.1 0.9 23% 1.0 12%
1 1e9 9.1 9.3 -2% 8.7 4%
2 1e7 0.1 0.1 7% 0.1 0%
2 1e8 1.3 1.0 40% 1.0 28%
2 1e9 11.5 9.3 23% 9.5 20%
3 1e7 0.2 0.1 26% 0.1 28%
3 1e8 1.4 1.5 -6% 1.5 -8%
3 1e9 14.5 12.8 13% 11.8 22%
4 1e7 0.2 0.2 7% 0.2 21%
4 1e8 1.6 1.5 0% 1.6 -1%
4 1e9 16.4 16.4 0% 14.9 10%
5 1e7 0.2 0.2 23% 0.2 11%
5 1e8 1.4 1.5 -2% 1.5 -1%
5 1e9 16.0 14.9 7% 13.0 22%
6 1e7 1.1 1.2 -5%
6 1e8 11.4 11.6 -1%
6 1e9 129.0 131.0 -1%
7 1e7 3.3 3.0 9%
7 1e8 35.6 28.8 23%
7 1e9 346.8 288.2 20%
8 1e7 3.4 3.1 9%
8 1e8 36.1 32.5 11%
8 1e9 463.2 405.2 14%
9 1e7 1.1 1.0 12% 1.4 -20%
9 1e8 4.3 4.0 6% 9.4 -54%
9 1e9 42.6 39.0 9% 121.0 -64%
10 1e7 1.5 1.5 3% 1.6 -5%
10 1e8 16.6 16.2 2% 16.6 0%
10 1e9 183.4 186.7 -1% 262.8 -30%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 3.5 3.5 -3% 3.3 -5%
1 1e1 5.5 5.1 12% 5.0 15%
1 2e0 5.4 5.5 -5% 6.5 -5%
2 1e2 4.3 3.5 23% 3.5 16%
2 1e1 5.5 4.8 30% 4.2 40%
2 2e0 6.6 5.7 0% 5.9 7%
3 1e2 5.4 4.8 11% 4.5 14%
3 1e1 10.9 9.5 6% 9.3 9%
3 2e0 213.7 213.2 2%
4 1e2 6.1 6.1 2% 5.6 10%
4 1e1 8.6 8.4 -3% 8.5 0%
4 2e0 8.1 7.8 -1%
5 1e2 5.9 5.5 9% 4.9 11%
5 1e1 14.0 10.2 19% 10.1 21%
5 2e0 4.2 3.6 9% 3.7 23%
6 1e2 47.2 47.9 -2%
6 1e1 40.5 39.4 0%
6 2e0 3.0 3.0 7%
7 1e2 128.6 106.7 17%
7 1e1 994.1
7 2e0 703.2 606.6 14%
8 1e2 167.6 146.9 11%
8 1e1 195.1 165.0 17%
8 2e0 826.2 728.6 11%
9 1e2 16.0 14.7 9% 43.9 -46%
9 1e1 27.8
9 2e0 1.6 1.5 8% 2.5 -35%
10 1e2 67.2 68.1 1% 93.7 -12%
10 1e1 15.0 14.0 0% 11.1 20%
10 2e0 10.9 10.8 1% 37.3 -72%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.1 1.1 6%
1e2 1e8 11.1 9.9 9%
1e2 1e9 123.3 111.3 8%
1e1 1e7 6.6 5.9 6%
1e1 1e8 71.6 61.7 11%
1e1 1e9
2e0 1e7 28.7 25.8 3%
2e0 1e8 284.8 248.9 3%
2e0 1e9 166.1 164.5 5%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 3.5 3.5 -3% 3.3 -5%
1e2 2 4.3 3.5 23% 3.5 16%
1e2 3 5.4 4.8 11% 4.5 14%
1e2 4 6.1 6.1 2% 5.6 10%
1e2 5 5.9 5.5 9% 4.9 11%
1e2 6 47.2 47.9 -2%
1e2 7 128.6 106.7 17%
1e2 8 167.6 146.9 11%
1e2 9 16.0 14.7 9% 43.9 -46%
1e2 10 67.2 68.1 1% 93.7 -12%
1e1 1 5.5 5.1 12% 5.0 15%
1e1 2 5.5 4.8 30% 4.2 40%
1e1 3 10.9 9.5 6% 9.3 9%
1e1 4 8.6 8.4 -3% 8.5 0%
1e1 5 14.0 10.2 19% 10.1 21%
1e1 6 40.5 39.4 0%
1e1 7 994.1
1e1 8 195.1 165.0 17%
1e1 9 27.8
1e1 10 15.0 14.0 0% 11.1 20%
2e0 1 5.4 5.5 -5% 6.5 -5%
2e0 2 6.6 5.7 0% 5.9 7%
2e0 3 213.7 213.2 2%
2e0 4 8.1 7.8 -1%
2e0 5 4.2 3.6 9% 3.7 23%
2e0 6 3.0 3.0 7%
2e0 7 703.2 606.6 14%
2e0 8 826.2 728.6 11%
2e0 9 1.6 1.5 8% 2.5 -35%
2e0 10 10.9 10.8 1% 37.3 -72%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 6%
0 1e8 11.1 9.9 9%
0 1e9 123.3 111.3 8%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 6%
0 1e8 11.1 9.9 9%
0 1e9 123.3 111.3 8%
1 1e7 1.1 1.0 17%
1 1e8 10.8 8.9 12%
1 1e9 117.3 98.7 26%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.2 3.2 5%
2 2.8 2.6 3%
3 5.3 5.2 6%
4 2.9 2.6 21%
5 14.6 14.2 4%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.1 1.0 12%
1e8 10.5 10.1 4%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 5.8 5.6 8%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 5.8 5.6 8%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.6 0.5 10%
1 1e8 5.9 5.9 0%
2 1e7 0.5 0.5 0%
2 1e8 5.2 4.8 6%
3 1e7 1.0 0.9 11%
3 1e8 9.6 9.4 1%
4 1e7 0.6 0.4 34%
4 1e8 5.2 4.8 8%
5 1e7 2.7 2.6 5%
5 1e8 26.5 25.8 2%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.0 12%
0 1e8 10.5 10.1 4%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.0 12%
0 1e8 10.5 10.1 4%

dplyr

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
3 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
4 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
5 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
6 68.9 73.5 -2% 70.3 -1% 69.4 0%
7 220.5 271.7 -8% 276.5 -9% 216.6 0%
8 496.0 570.5 -5% 575.4 -6% 490.3 0%
9 56.5 57.3 -1% 67.3 -6% 55.7 1%
10 63.7 61.5 3% 63.7 0% 61.7 3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 141.2 154.7 -1% 157.2 -3% 139.5 1%
1e1 139.9 136.8 0% 132.3 0% 136.2 1%
2e0 64.9 64.9 1% 66.4 0% 66.3 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 141.2 154.7 -1% 157.2 -3% 139.5 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 141.2 154.7 -1% 157.2 -3% 139.5 1%
1 137.2 136.1 0% 136.4 0%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.4 0% 0.4 3% 0.4 4% 0.2 88%
1 1e8 3.6 3.6 1% 3.7 -2% 3.6 0% 2.2 63%
1 1e9 38.1 37.5 1% 41.3 -7% 37.6 1% 22.2 71%
2 1e7 0.8 0.8 0% 0.8 2% 0.8 3% 0.5 76%
2 1e8 9.3 9.5 -1% 9.5 -2% 9.5 -1% 6.6 40%
2 1e9 102.0 103.6 -1% 98.7 3% 102.0 0% 78.6 29%
3 1e7 1.3 1.5 -7% 1.4 -5% 1.4 -2% 0.7 84%
3 1e8 37.0 36.8 0% 37.0 0% 37.4 -1% 16.8 119%
3 1e9 495.1 501.0 -1% 501.4 -1% 495.4 0% 233.8 111%
4 1e7 0.6 0.6 0% 0.6 0% 0.6 7% 0.6 10%
4 1e8 8.7 8.2 6% 8.5 1% 8.5 2% 8.3 4%
4 1e9 89.9 89.6 0% 92.9 -3% 90.0 0% 83.4 7%
5 1e7 1.5 1.5 -2% 1.6 -7% 1.5 2% 1.5 1%
5 1e8 37.9 38.2 0% 37.6 0% 37.9 0% 39.1 -2%
5 1e9 538.0 519.6 3% 532.6 1% 520.5 3% 528.6 1%
6 1e7 1.7 1.7 2% 1.7 0% 1.7 2%
6 1e8 15.9 16.7 -4% 16.3 -2% 16.0 0%
6 1e9 189.2 202.0 -6% 192.9 -1% 190.6 0%
7 1e7 1.7 1.7 -2% 1.8 -5% 1.7 1%
7 1e8 39.1 39.7 -1% 39.9 -1% 39.7 -1%
7 1e9 620.8 773.7 -19% 787.8 -21% 608.4 2%
8 1e7 6.7 6.7 0% 7.0 -4% 6.7 0%
8 1e8 104.5 108.3 -3% 106.0 -1% 104.6 0%
8 1e9 1376.7 1596.6 -13% 1613.3 -14% 1359.7 1%
9 1e7 1.5 1.4 3% 1.5 0% 1.4 4%
9 1e8 12.2 13.1 -6% 12.5 -1% 12.2 0%
9 1e9 155.9 157.5 0% 188.0 -17% 153.5 1%
10 1e7 63.7 61.5 3% 63.7 0% 61.7 3%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
1 1e1 12.1 12.8 0% 12.8 0% 12.4 3% 5.0 147%
1 2e0 10.9 10.7 3% 10.9 0% 10.8 1% 5.1 146%
2 1e2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
2 1e1 24.0 23.2 1% 24.0 0% 24.1 3% 12.9 114%
2 2e0 20.1 20.0 2% 20.6 -3% 20.0 2% 8.0 164%
3 1e2 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
3 1e1 401.8 397.4 0% 395.2 0% 410.8 -1% 171.9 132%
3 2e0 110.1 109.5 3% 110.9 2% 110.6 3% 53.8 149%
4 1e2 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
4 1e1 18.9 18.6 2% 18.7 -1% 19.5 2% 16.2 14%
4 2e0 1.6 1.6 0% 1.6 0% 1.6 1% 1.6 5%
5 1e2 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
5 1e1 532.5 508.0 1% 475.7 3% 490.3 4% 463.9 -4%
5 2e0 83.8 81.9 0% 86.6 -1% 85.2 1% 110.8 -17%
6 1e2 68.9 73.5 -2% 70.3 -1% 69.4 0%
6 1e1 45.1 45.3 0% 44.8 0% 46.2 0%
6 2e0 4.0 4.0 0% 4.0 -1% 4.0 1%
7 1e2 220.5 271.7 -8% 276.5 -9% 216.6 0%
7 1e1 57.8 58.5 -1% 57.5 0% 57.9 0%
7 2e0 159.3 160.1 0% 165.4 -2% 164.3 -1%
8 1e2 496.0 570.5 -5% 575.4 -6% 490.3 0%
8 1e1 102.4 105.1 -2% 102.2 0% 102.2 0%
8 2e0 236.9 239.3 0% 241.7 -1% 244.1 -2%
9 1e2 56.5 57.3 -1% 67.3 -6% 55.7 1%
9 1e1 4.1 4.1 0% 3.9 1% 3.9 2%
9 2e0 3.2 3.2 0% 3.2 0% 3.3 -2%
10 1e2 63.7 61.5 3% 63.7 0% 61.7 3%
10 1e1 67.0 67.6 0% 66.3 1% 67.2 0%
10 2e0 72.6 72.2 0% 72.4 0% 72.9 0%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
1e2 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
1e2 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
1e1 1e7 10.7 10.8 0% 10.6 0% 10.7 3%
1e1 1e8 53.8 55.0 0% 53.8 1% 53.8 1%
1e1 1e9 484.6 469.4 0% 452.8 1% 469.0 0%
2e0 1e7 17.6 17.4 1% 17.5 0% 17.4 2%
2e0 1e8 122.7 122.9 0% 126.0 0% 126.0 -1%
2e0 1e9 41.8 41.6 0% 42.6 -1% 41.6 0% 17.9 128%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 14.0 13.8 1% 15.1 -2% 13.9 2% 8.2 74%
1e2 2 37.4 38.0 -1% 36.3 1% 37.4 0% 28.6 48%
1e2 3 177.8 179.8 -2% 180.0 -2% 178.1 -1% 83.8 105%
1e2 4 33.1 32.8 2% 34.0 0% 33.0 3% 30.8 7%
1e2 5 192.5 186.4 0% 190.6 -1% 186.6 2% 189.7 0%
1e2 6 68.9 73.5 -2% 70.3 -1% 69.4 0%
1e2 7 220.5 271.7 -8% 276.5 -9% 216.6 0%
1e2 8 496.0 570.5 -5% 575.4 -6% 490.3 0%
1e2 9 56.5 57.3 -1% 67.3 -6% 55.7 1%
1e2 10 63.7 61.5 3% 63.7 0% 61.7 3%
1e1 1 12.1 12.8 0% 12.8 0% 12.4 3% 5.0 147%
1e1 2 24.0 23.2 1% 24.0 0% 24.1 3% 12.9 114%
1e1 3 401.8 397.4 0% 395.2 0% 410.8 -1% 171.9 132%
1e1 4 18.9 18.6 2% 18.7 -1% 19.5 2% 16.2 14%
1e1 5 532.5 508.0 1% 475.7 3% 490.3 4% 463.9 -4%
1e1 6 45.1 45.3 0% 44.8 0% 46.2 0%
1e1 7 57.8 58.5 -1% 57.5 0% 57.9 0%
1e1 8 102.4 105.1 -2% 102.2 0% 102.2 0%
1e1 9 4.1 4.1 0% 3.9 1% 3.9 2%
1e1 10 67.0 67.6 0% 66.3 1% 67.2 0%
2e0 1 10.9 10.7 3% 10.9 0% 10.8 1% 5.1 146%
2e0 2 20.1 20.0 2% 20.6 -3% 20.0 2% 8.0 164%
2e0 3 110.1 109.5 3% 110.9 2% 110.6 3% 53.8 149%
2e0 4 1.6 1.6 0% 1.6 0% 1.6 1% 1.6 5%
2e0 5 83.8 81.9 0% 86.6 -1% 85.2 1% 110.8 -17%
2e0 6 4.0 4.0 0% 4.0 -1% 4.0 1%
2e0 7 159.3 160.1 0% 165.4 -2% 164.3 -1%
2e0 8 236.9 239.3 0% 241.7 -1% 244.1 -2%
2e0 9 3.2 3.2 0% 3.2 0% 3.3 -2%
2e0 10 72.6 72.2 0% 72.4 0% 72.9 0%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
0 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
0 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 8.0 7.8 0% 8.1 -1% 7.8 2%
0 1e8 29.8 30.4 -1% 30.1 -1% 29.9 0%
0 1e9 400.6 442.3 -4% 449.9 -6% 395.3 0%
1 1e7 6.8 6.8 -3% 6.8 -4% 6.8 -2%
1 1e8 27.8 27.0 3% 27.6 1% 27.1 1%
1 1e9 391.5 389.0 0% 389.7 1%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 11.1 11.4 -2% 11.2 0%
2 8.2 8.3 3% 8.3 -2%
3 8.5 8.5 -2% 8.7 -1%
4 12.8 12.8 -2% 12.9 -2%
5 64.1 63.9 0% 65.2 -3%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 4.2 4.3 0% 4.3 -3%
1e8 37.7 37.7 0% 38.2 -1%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 20.9 21.0 0% 21.3 -2%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 20.9 21.0 0% 21.3 -2%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 6.0 6.1 -1% 6.0 0%
1 1e8 16.2 16.7 -3% 16.3 0%
2 1e7 1.4 1.3 9% 1.5 -4%
2 1e8 14.9 15.3 -2% 15.1 -1%
3 1e7 1.4 1.4 -5% 1.4 -1%
3 1e8 15.7 15.7 0% 16.0 -1%
4 1e7 2.0 2.1 -5% 2.1 -4%
4 1e8 23.6 23.5 0% 23.8 0%
5 1e7 10.1 10.3 -1% 10.7 -5%
5 1e8 118.0 117.4 0% 119.7 -1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.2 4.3 0% 4.3 -3%
0 1e8 37.7 37.7 0% 38.2 -1%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.2 4.3 0% 4.3 -3%
0 1e8 37.7 37.7 0% 38.2 -1%

pandas

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
3 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
4 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
5 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
6 8.8 8.7 -3% 8.6 0% 8.6 0%
7 3.7 3.6 1% 3.5 -3% 3.4 -7%
8 28.3 26.1 2% 26.9 3% 25.9 4%
9 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
10 113.3
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7
1e8
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.3 0% 0.3 -20% 0.3 2% 0.2 20%
1 1e8 2.0 2.1 -3% 1.9 7% 2.0 0% 1.7 16%
2 1e7 0.7 0.7 11% 0.8 -6% 0.8 -4% 0.6 24%
2 1e8 7.7 7.6 0% 7.3 5% 6.7 14% 6.0 28%
3 1e7 0.5 0.5 -8% 0.5 4% 0.6 -20% 0.5 10%
3 1e8 8.3 8.8 -5% 8.3 0% 7.0 18% 8.0 4%
4 1e7 0.5 0.6 -8% 0.5 -4% 0.5 0% 0.5 12%
4 1e8 5.4 5.6 -3% 5.3 3% 5.4 1% 4.6 17%
5 1e7 0.9 1.0 -3% 0.9 4% 1.2 -19% 1.0 -5%
5 1e8 14.9 14.8 0% 15.0 -1% 13.5 10% 15.9 -6%
6 1e7 1.5 1.7 -9% 1.6 -1% 1.6 -5%
6 1e8 16.2 15.7 2% 15.6 3% 15.6 3%
7 1e7 0.5 0.5 1% 0.6 -12% 0.7 -25%
7 1e8 6.8 6.7 1% 6.5 4% 6.1 10%
8 1e7 3.6 3.7 -4% 3.5 2% 3.6 0%
8 1e8 53.0 48.5 9% 50.4 5% 48.3 9%
9 1e7 12.8 13.3 -3% 12.6 1% 13.4 -4% 11.0 16%
9 1e8 45.8 43.8 4% 44.6 2% 45.5 0% 43.2 6%
10 1e7 9.7
10 1e8 216.9
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
1 1e1 1.1 1.1 2% 1.0 4% 1.1 0% 1.0 12%
1 2e0 1.1 1.1 3% 1.1 4% 1.2 -1% 1.0 17%
2 1e2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
2 1e1 3.2 3.3 -5% 3.5 -3% 2.9 4% 2.6 13%
2 2e0 3.0 3.0 -3% 3.2 -3% 2.8 2% 2.6 15%
3 1e2 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
3 1e1 8.4 8.6 2% 8.6 0% 8.1 4% 10.8 -24%
3 2e0 14.6 14.7 0% 15.8 -3% 13.4 7% 30.1 -48%
4 1e2 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
4 1e1 2.9 2.9 1% 2.9 1% 2.9 3% 2.5 16%
4 2e0 2.9 3.0 -3% 2.9 0% 2.9 0% 2.5 13%
5 1e2 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
5 1e1 15.9 16.7 -1% 17.3 -5% 15.8 1% 15.9 -2%
5 2e0 32.6 31.9 2% 33.8 0% 31.7 3% 30.2 7%
6 1e2 8.8 8.7 -3% 8.6 0% 8.6 0%
6 1e1 6.2 6.3 0% 6.3 -1% 6.1 2%
6 2e0 5.6 5.6 2% 5.9 0% 5.5 4%
7 1e2 3.7 3.6 1% 3.5 -3% 3.4 -7%
7 1e1 8.2 8.4 -1% 8.3 -2% 7.8 8%
7 2e0 17.8 17.7 1% 17.9 0% 16.4 8%
8 1e2 28.3 26.1 2% 26.9 3% 25.9 4%
8 1e1 32.8 32.5 1% 33.1 0% 32.9 0%
8 2e0 48.1 48.1 1% 48.8 0% 47.8 0%
9 1e2 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
9 1e1 15.1 15.2 0% 15.3 1% 15.0 1% 15.3 1%
9 2e0 11.3 11.0 2% 11.2 2% 10.6 4% 11.9 -3%
10 1e2 113.3
10 1e1 67.4
10 2e0 91.9
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7
1e2 1e8
1e1 1e7
1e1 1e8
2e0 1e7
2e0 1e8
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 1.1 1.2 -1% 1.1 -6% 1.1 0% 1.0 18%
1e2 2 4.2 4.1 6% 4.0 0% 3.8 5% 3.3 26%
1e2 3 4.4 4.7 -7% 4.4 2% 3.8 0% 4.2 7%
1e2 4 3.0 3.1 -6% 2.9 0% 2.9 0% 2.5 15%
1e2 5 7.9 7.9 -1% 7.9 1% 7.3 -4% 8.4 -6%
1e2 6 8.8 8.7 -3% 8.6 0% 8.6 0%
1e2 7 3.7 3.6 1% 3.5 -3% 3.4 -7%
1e2 8 28.3 26.1 2% 26.9 3% 25.9 4%
1e2 9 29.3 28.6 0% 28.6 2% 29.5 -2% 27.1 11%
1e2 10 113.3
1e1 1 1.1 1.1 2% 1.0 4% 1.1 0% 1.0 12%
1e1 2 3.2 3.3 -5% 3.5 -3% 2.9 4% 2.6 13%
1e1 3 8.4 8.6 2% 8.6 0% 8.1 4% 10.8 -24%
1e1 4 2.9 2.9 1% 2.9 1% 2.9 3% 2.5 16%
1e1 5 15.9 16.7 -1% 17.3 -5% 15.8 1% 15.9 -2%
1e1 6 6.2 6.3 0% 6.3 -1% 6.1 2%
1e1 7 8.2 8.4 -1% 8.3 -2% 7.8 8%
1e1 8 32.8 32.5 1% 33.1 0% 32.9 0%
1e1 9 15.1 15.2 0% 15.3 1% 15.0 1% 15.3 1%
1e1 10 67.4
2e0 1 1.1 1.1 3% 1.1 4% 1.2 -1% 1.0 17%
2e0 2 3.0 3.0 -3% 3.2 -3% 2.8 2% 2.6 15%
2e0 3 14.6 14.7 0% 15.8 -3% 13.4 7% 30.1 -48%
2e0 4 2.9 3.0 -3% 2.9 0% 2.9 0% 2.5 13%
2e0 5 32.6 31.9 2% 33.8 0% 31.7 3% 30.2 7%
2e0 6 5.6 5.6 2% 5.9 0% 5.5 4%
2e0 7 17.8 17.7 1% 17.9 0% 16.4 8%
2e0 8 48.1 48.1 1% 48.8 0% 47.8 0%
2e0 9 11.3 11.0 2% 11.2 2% 10.6 4% 11.9 -3%
2e0 10 91.9
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8
1 1e7
1 1e8

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 41.6 45.5 -3% 43.5 0% 46.6 5%
2 68.3 67.2 1% 67.4 0% 62.8 20%
3 37.2 37.7 0% 37.7 -1% 30.3 17%
4 60.2 60.1 0% 59.5 0% 48.1 33%
5 197.0 196.7 0% 194.8 0% 381.8 -52%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 9.9 9.8 1% 9.9 0% 14.7 10%
1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 80.8 81.5 0% 80.6 0% 113.9 4%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 80.8 81.5 0% 80.6 0% 113.9 4%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.4 4.2 3% 4.3 2% 3.6 22%
1 1e8 78.7 86.9 -9% 82.7 -4% 89.7 -12%
2 1e7 9.6 9.4 2% 9.7 0% 7.2 33%
2 1e8 126.9 125.1 1% 125.1 1% 118.5 7%
3 1e7 5.3 5.3 0% 5.3 0% 4.7 11%
3 1e8 69.0 70.2 -1% 70.0 -1% 55.9 23%
4 1e7 7.9 7.8 1% 7.8 0% 5.6 41%
4 1e8 112.5 112.4 0% 111.1 1% 90.5 24%
5 1e7 22.4 22.4 0% 22.3 0% 52.2 -57%
5 1e8 371.5 371.0 0% 367.4 1% 711.4 -47%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.9 9.8 1% 9.9 0% 14.7 10%
0 1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.9 9.8 1% 9.9 0% 14.7 10%
0 1e8 151.7 153.1 -1% 151.3 0% 213.2 -1%

pydatatable

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 14.8 15.5 5% 14.6 3% 18.6 -9%
2 21.0 20.0 9% 19.0 18%
3 56.4 45.1 23% 45.2 35%
4 39.1 41.5 1% 38.3 2%
5 10.1 9.4 12% 9.4 12%
6 103.0 90.6 11% 90.6 14%
7 50.5 44.5 17% 44.4 17%
8 109.5 97.7 22% 95.8 26%
9 7.2 7.2 10% 7.2 10%
10 264.4 237.0 12% 246.2 12%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.0 1.8 18% 1.7 22%
1e8 24.0 19.9 13% 19.9 14%
1e9 176.8 161.0 6% 161.7 8%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 67.6 60.9 12% 61.1 15%
1e1 68.6 63.5 8% 61.5 12%
2e0 89.8 78.6 5% 77.7 5%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 67.6 60.9 12% 61.1 15%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 67.6 60.9 12% 61.1 15%
1 52.3 46.6 15% 49.3 11%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.4 9% 0.4 4% 0.5 -19%
1 1e8 3.9 3.5 12% 3.8 3% 3.5 11%
1 1e9 40.2 42.6 -5% 39.8 1% 51.7 -22%
2 1e7 0.6 0.5 15% 0.5 14%
2 1e8 6.0 5.6 8% 4.6 31%
2 1e9 56.3 53.8 4% 51.8 8%
3 1e7 1.5 1.0 42% 0.9 62%
3 1e8 11.4 11.2 1% 9.7 17%
3 1e9 156.4 123.2 27% 125.0 25%
4 1e7 0.9 0.9 0% 0.8 7%
4 1e8 11.2 10.2 10% 11.6 -3%
4 1e9 105.2 113.5 -7% 102.4 2%
5 1e7 0.3 0.3 20% 0.3 18%
5 1e8 3.9 3.5 10% 3.5 11%
5 1e9 26.1 24.5 6% 24.4 7%
6 1e7 1.5 1.6 -8% 1.4 4%
6 1e8 85.2 62.5 36% 65.3 30%
6 1e9 222.3 207.8 6% 205.1 8%
7 1e7 1.1 0.9 24% 0.9 23%
7 1e8 11.1 9.8 13% 9.8 13%
7 1e9 139.4 122.8 13% 122.4 13%
8 1e7 4.4 3.2 38% 3.0 47%
8 1e8 31.3 26.3 18% 26.2 19%
8 1e9 292.9 263.6 11% 258.3 13%
9 1e7 0.3 0.2 28% 0.2 29%
9 1e8 2.0 1.9 4% 1.9 4%
9 1e9 19.3 19.6 -1% 19.6 -1%
10 1e7 9.5 8.7 9% 8.3 13%
10 1e8 74.0 64.0 15% 62.3 18%
10 1e9 709.5 638.4 11% 668.0 6%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 14.8 15.5 5% 14.6 3% 18.6 -9%
1 1e1 7.7 7.0 0% 7.0 3% 7.9 -10%
1 2e0 6.7 7.8 -4% 6.8 0% 6.6 -6%
2 1e2 21.0 20.0 9% 19.0 18%
2 1e1 20.2 24.1 11% 17.2 22%
2 2e0 9.7 10.8 -7% 9.4 -9%
3 1e2 56.4 45.1 23% 45.2 35%
3 1e1 117.1 108.9 10% 107.3 3%
3 2e0 239.6 203.6 11% 200.5 11%
4 1e2 39.1 41.5 1% 38.3 2%
4 1e1 14.1 14.1 2% 13.1 6%
4 2e0 11.8 11.0 5% 11.9 0%
5 1e2 10.1 9.4 12% 9.4 12%
5 1e1 58.0 50.7 0% 50.3 8%
5 2e0 29.1 25.6 16% 26.5 10%
6 1e2 103.0 90.6 11% 90.6 14%
6 1e1 30.8 31.2 2% 30.0 7%
6 2e0 12.7 12.1 6% 12.2 9%
7 1e2 50.5 44.5 17% 44.4 17%
7 1e1 113.8 104.3 10% 100.8 9%
7 2e0 221.7 189.0 12% 191.6 12%
8 1e2 109.5 97.7 22% 95.8 26%
8 1e1 55.9 49.6 36% 48.5 35%
8 2e0 28.9 26.6 6% 27.1 5%
9 1e2 7.2 7.2 10% 7.2 10%
9 1e1 6.5 6.3 -1% 6.1 6%
9 2e0 6.0 6.0 0% 5.9 3%
10 1e2 264.4 237.0 12% 246.2 12%
10 1e1 261.7 238.8 18% 234.2 18%
10 2e0 331.7 293.0 11% 285.3 13%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.0 1.8 18% 1.7 22%
1e2 1e8 24.0 19.9 13% 19.9 14%
1e2 1e9 176.8 161.0 6% 161.7 8%
1e1 1e7 1.8 1.5 11% 1.6 11%
1e1 1e8 15.4 14.4 10% 13.5 14%
1e1 1e9 188.5 174.6 4% 169.2 10%
2e0 1e7 2.2 2.1 6% 2.1 5%
2e0 1e8 21.4 19.6 4% 19.5 4%
2e0 1e9 245.7 214.0 5% 211.6 7%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 14.8 15.5 5% 14.6 3% 18.6 -9%
1e2 2 21.0 20.0 9% 19.0 18%
1e2 3 56.4 45.1 23% 45.2 35%
1e2 4 39.1 41.5 1% 38.3 2%
1e2 5 10.1 9.4 12% 9.4 12%
1e2 6 103.0 90.6 11% 90.6 14%
1e2 7 50.5 44.5 17% 44.4 17%
1e2 8 109.5 97.7 22% 95.8 26%
1e2 9 7.2 7.2 10% 7.2 10%
1e2 10 264.4 237.0 12% 246.2 12%
1e1 1 7.7 7.0 0% 7.0 3% 7.9 -10%
1e1 2 20.2 24.1 11% 17.2 22%
1e1 3 117.1 108.9 10% 107.3 3%
1e1 4 14.1 14.1 2% 13.1 6%
1e1 5 58.0 50.7 0% 50.3 8%
1e1 6 30.8 31.2 2% 30.0 7%
1e1 7 113.8 104.3 10% 100.8 9%
1e1 8 55.9 49.6 36% 48.5 35%
1e1 9 6.5 6.3 -1% 6.1 6%
1e1 10 261.7 238.8 18% 234.2 18%
2e0 1 6.7 7.8 -4% 6.8 0% 6.6 -6%
2e0 2 9.7 10.8 -7% 9.4 -9%
2e0 3 239.6 203.6 11% 200.5 11%
2e0 4 11.8 11.0 5% 11.9 0%
2e0 5 29.1 25.6 16% 26.5 10%
2e0 6 12.7 12.1 6% 12.2 9%
2e0 7 221.7 189.0 12% 191.6 12%
2e0 8 28.9 26.6 6% 27.1 5%
2e0 9 6.0 6.0 0% 5.9 3%
2e0 10 331.7 293.0 11% 285.3 13%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.8 18% 1.7 22%
0 1e8 24.0 19.9 13% 19.9 14%
0 1e9 176.8 161.0 6% 161.7 8%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.8 18% 1.7 22%
0 1e8 24.0 19.9 13% 19.9 14%
0 1e9 176.8 161.0 6% 161.7 8%
1 1e7 1.7 1.5 28% 1.5 19%
1 1e8 20.7 18.3 9% 22.3 5%
1 1e9 134.5 119.9 10% 124.1 9%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 14.9 14.4 -1% 13.3 6%
2 15.1 15.6 -1% 14.8 -5%
3 5.9 5.7 9% 5.8 -13%
4 59.4 57.3 6% 57.4 9%
5 241.6 261.1 1% 167.5 15%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.4 1.5 0% 1.2 -5%
1e8 12.6 10.7 9% 18.8 -3%
1e9 188.1 200.3 0% 135.4 16%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 67.4 70.8 2% 51.8 2%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 67.4 70.8 2% 51.8 2%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.2 0.3 -10% 0.2 2%
1 1e8 2.3 2.3 1% 2.3 3%
1 1e9 42.2 40.8 3% 37.4 12%
2 1e7 0.3 0.3 0% 0.4 -19%
2 1e8 3.1 3.2 -1% 3.1 0%
2 1e9 42.0 43.2 -2% 41.0 2%
3 1e7 0.1 0.1 20% 0.2 -35%
3 1e8 1.2 1.2 4% 1.3 -7%
3 1e9 16.3 16.0 2% 15.9 2%
4 1e7 0.4 0.4 -5% 0.4 0%
4 1e8 5.3 4.4 21% 4.2 26%
4 1e9 172.4 167.2 3% 167.7 2%
5 1e7 5.9 6.4 -7% 4.7 25%
5 1e8 51.1 42.3 20% 83.1 -38%
5 1e9 667.7 734.5 -9% 414.8 60%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.4 1.5 0% 1.2 -5%
0 1e8 12.6 10.7 9% 18.8 -3%
0 1e9 188.1 200.3 0% 135.4 16%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.4 1.5 0% 1.2 -5%
0 1e8 12.6 10.7 9% 18.8 -3%
0 1e9 188.1 200.3 0% 135.4 16%

spark

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 7.6 10.2 -23% 6.0 30% 7.4 0%
2 9.9 10.1 -11% 9.9 -4% 9.7 4%
3 28.3 27.9 3% 31.3 -5% 186.3 -27%
4 3.5 3.5 2% 3.5 2% 4.0 -13%
5 21.5 21.9 -1% 22.0 -3% 65.0 -23%
7 28.5 25.5 12% 26.5 4%
8 47.4 47.6 -1% 52.3 -3%
9 9.3 9.4 -2% 9.7 -17% 12.8 -11%
10 230.6 249.6 0% 280.2 -3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.0 2.1 -4% 2.2 -7%
1e8 9.1 9.7 -3% 8.6 7%
1e9 117.8 123.4 0% 136.4 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 43.0 45.1 -2% 49.1 0%
1e1 47.0 67.7 -4% 45.4 1%
2e0 48.0 61.1 1% 46.9 -1%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 43.0 45.1 -2% 49.1 0%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 43.0 45.1 -2% 49.1 0%
1 46.3 45.5 6% 42.4 8%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 2.1 2.2 -3% 1.7 28% 2.2 -3%
1 1e8 3.0 12.2 -75% 2.2 37% 3.0 0%
1 1e9 17.6 16.4 7% 14.1 24% 16.9 3%
2 1e7 1.5 2.3 -34% 1.7 -12% 1.4 7%
2 1e8 3.7 3.7 0% 3.8 -1% 3.6 3%
2 1e9 24.5 24.4 0% 24.4 0% 24.1 1%
3 1e7 1.7 1.7 -1% 2.0 -14% 1.7 0%
3 1e8 7.0 6.3 10% 6.3 9% 6.7 4%
3 1e9 76.4 75.7 0% 85.5 -10% 550.6 -86%
4 1e7 0.8 0.8 7% 0.7 13% 0.9 -8%
4 1e8 1.2 1.2 0% 1.3 -6% 1.6 -21%
4 1e9 8.6 8.5 0% 8.5 0% 9.5 -10%
5 1e7 1.3 1.4 -4% 1.5 -11% 1.4 -5%
5 1e8 5.0 5.0 0% 4.8 5% 4.8 4%
5 1e9 58.1 59.3 -1% 59.8 -2% 188.8 -69%
7 1e7 1.6 1.5 6% 1.7 -9%
7 1e8 6.8 5.7 18% 5.9 14%
7 1e9 77.1 69.3 11% 71.8 7%
8 1e7 2.5 2.5 -3% 2.5 -3%
8 1e8 10.2 10.3 -1% 9.9 3%
8 1e9 129.6 130.0 0% 144.5 -10%
9 1e7 1.2 1.4 -13% 2.8 -56% 1.4 -10%
9 1e8 3.2 3.0 8% 3.1 2% 3.0 6%
9 1e9 23.4 23.7 -1% 23.2 0% 33.9 -30%
10 1e7 5.2 5.0 3% 5.1 2% 5.2 1%
10 1e8 41.6 40.4 2% 39.8 4% 40.0 3%
10 1e9 645.1 703.5 -8% 795.8 -18%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 7.6 10.2 -23% 6.0 30% 7.4 0%
1 1e1 5.2 5.6 0% 6.0 -17% 6.0 -3%
1 2e0 5.3 5.3 8% 5.6 -12% 6.4 -2%
2 1e2 9.9 10.1 -11% 9.9 -4% 9.7 4%
2 1e1 7.2 8.1 -14% 7.4 -3% 9.4 -6%
2 2e0 5.8 5.5 22% 5.7 7% 5.8 7%
3 1e2 28.3 27.9 3% 31.3 -5% 186.3 -27%
3 1e1 35.1 46.8 -13% 35.9 -2% 174.8 -26%
3 2e0 52.8 61.5 0% 55.6 4% 305.2 -28%
4 1e2 3.5 3.5 2% 3.5 2% 4.0 -13%
4 1e1 3.5 3.2 20% 3.3 18% 3.2 17%
4 2e0 3.2 3.3 2% 3.3 -4% 4.1 -13%
5 1e2 21.5 21.9 -1% 22.0 -3% 65.0 -23%
5 1e1 30.6 40.3 -3% 31.1 0% 65.8 -30%
5 2e0 44.5 51.6 -5% 46.0 -10% 94.5 -17%
7 1e2 28.5 25.5 12% 26.5 4%
7 1e1 33.5 51.0 -16% 33.0 0%
7 2e0 45.6 54.6 -8% 47.5 -8%
8 1e2 47.4 47.6 -1% 52.3 -3%
8 1e1 47.8 56.8 0% 48.4 9%
8 2e0 49.7 53.2 -4% 51.1 0%
9 1e2 9.3 9.4 -2% 9.7 -17% 12.8 -11%
9 1e1 6.5 6.6 0% 6.5 4% 7.0 0%
9 2e0 5.4 5.1 8% 5.2 5% 7.2 -13%
10 1e2 230.6 249.6 0% 280.2 -3%
10 1e1 253.3 391.2 -10% 236.6 6% 467.2 -17%
10 2e0 219.9 309.7 -10% 201.8 5%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.0 2.1 -4% 2.2 -7%
1e2 1e8 9.1 9.7 -3% 8.6 7%
1e2 1e9 117.8 123.4 0% 136.4 0%
1e1 1e7 2.2 2.2 4% 2.1 5%
1e1 1e8 10.0 10.1 0% 9.7 1%
1e1 1e9 128.7 190.9 -17% 124.3 -1%
2e0 1e7 2.3 2.2 12% 2.3 0%
2e0 1e8 11.5 11.6 0% 11.7 -4%
2e0 1e9 130.3 169.4 -9% 126.6 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 7.6 10.2 -23% 6.0 30% 7.4 0%
1e2 2 9.9 10.1 -11% 9.9 -4% 9.7 4%
1e2 3 28.3 27.9 3% 31.3 -5% 186.3 -27%
1e2 4 3.5 3.5 2% 3.5 2% 4.0 -13%
1e2 5 21.5 21.9 -1% 22.0 -3% 65.0 -23%
1e2 7 28.5 25.5 12% 26.5 4%
1e2 8 47.4 47.6 -1% 52.3 -3%
1e2 9 9.3 9.4 -2% 9.7 -17% 12.8 -11%
1e2 10 230.6 249.6 0% 280.2 -3%
1e1 1 5.2 5.6 0% 6.0 -17% 6.0 -3%
1e1 2 7.2 8.1 -14% 7.4 -3% 9.4 -6%
1e1 3 35.1 46.8 -13% 35.9 -2% 174.8 -26%
1e1 4 3.5 3.2 20% 3.3 18% 3.2 17%
1e1 5 30.6 40.3 -3% 31.1 0% 65.8 -30%
1e1 7 33.5 51.0 -16% 33.0 0%
1e1 8 47.8 56.8 0% 48.4 9%
1e1 9 6.5 6.6 0% 6.5 4% 7.0 0%
1e1 10 253.3 391.2 -10% 236.6 6% 467.2 -17%
2e0 1 5.3 5.3 8% 5.6 -12% 6.4 -2%
2e0 2 5.8 5.5 22% 5.7 7% 5.8 7%
2e0 3 52.8 61.5 0% 55.6 4% 305.2 -28%
2e0 4 3.2 3.3 2% 3.3 -4% 4.1 -13%
2e0 5 44.5 51.6 -5% 46.0 -10% 94.5 -17%
2e0 7 45.6 54.6 -8% 47.5 -8%
2e0 8 49.7 53.2 -4% 51.1 0%
2e0 9 5.4 5.1 8% 5.2 5% 7.2 -13%
2e0 10 219.9 309.7 -10% 201.8 5%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 2.1 -4% 2.2 -7%
0 1e8 9.1 9.7 -3% 8.6 7%
0 1e9 117.8 123.4 0% 136.4 0%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 2.1 -4% 2.2 -7%
0 1e8 9.1 9.7 -3% 8.6 7%
0 1e9 117.8 123.4 0% 136.4 0%
1 1e7 2.1 2.2 0% 2.2 -2%
1 1e8 8.9 8.7 21% 8.3 22%
1 1e9 128.0 125.6 -2% 116.7 5%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 267.8 228.7 8% 206.8 13%
2 617.4 630.5 0% 619.1 1%
3 688.3 836.0 -5% 501.2 14%
4 606.4 640.8
5 45.4 45.7 -2% 45.1 2%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 6.1 6.2 1% 5.8 7%
1e8 51.2 51.1 0% 50.8 0%
1e9 1677.5 1427.8
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 499.7 428.1
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 499.7 428.1
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.7 4.5 6% 4.3 9%
1 1e8 36.9 37.1 0% 37.1 0%
1 1e9 761.8 644.4 18% 578.8 31%
2 1e7 4.2 4.2 0% 4.1 4%
2 1e8 45.8 45.2 1% 45.1 1%
2 1e9 1802.0 1842.0 -2% 1808.2 0%
3 1e7 4.8 4.8 0% 4.6 3%
3 1e8 49.6 49.1 0% 48.8 1%
3 1e9 2010.5 2454.1 -18% 1450.3 38%
4 1e7 5.0 4.8 3% 4.3 14%
4 1e8 44.8 44.8 0% 44.2 1%
4 1e9 1769.6 1873.7
5 1e7 11.9 12.5 -4% 11.4 4%
5 1e8 78.9 78.9 0% 78.9 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.1 6.2 1% 5.8 7%
0 1e8 51.2 51.1 0% 50.8 0%
0 1e9 1677.5 1427.8
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.1 6.2 1% 5.8 7%
0 1e8 51.2 51.1 0% 50.8 0%
0 1e9 1677.5 1427.8

cudf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.2
2 0.2
3 0.6
4 0.5
5 0.6
10 5.4
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.3 0.3 55% 0.2 255%
1e8 2.3
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1.3
1e1 1.4
2e0 1.7
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1.3
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1.3
1 1.3
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.0 186% 0.0 173%
1 1e8 0.4
2 1e7 0.1 0.0 96% 0.0 111%
2 1e8 0.3
3 1e7 1.0 0.9 13% 0.1 1248%
3 1e8 1.1
4 1e7 0.3 0.2 35% 0.2 12%
4 1e8 0.8
5 1e7 0.1 0.1 1% 0.1 -6%
5 1e8 1.1
10 1e7 0.5 0.5 1% 0.6 -9%
10 1e8 10.3
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 0.2
1 1e1 0.2
1 2e0 0.2
2 1e2 0.2
2 1e1 0.2
2 2e0 0.2
3 1e2 0.6
3 1e1 0.8
3 2e0 1.4
4 1e2 0.5
4 1e1 0.4
4 2e0 0.5
5 1e2 0.6
5 1e1 0.8
5 2e0 1.5
10 1e2 5.4
10 1e1 5.8
10 2e0 6.2
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.3 0.3 55% 0.2 255%
1e2 1e8 2.3
1e1 1e7 0.1 0.1 1% 0.2 -1%
1e1 1e8 2.6
2e0 1e7 0.2 0.2 0% 0.2 6%
2e0 1e8 3.1
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 0.2
1e2 2 0.2
1e2 3 0.6
1e2 4 0.5
1e2 5 0.6
1e2 10 5.4
1e1 1 0.2
1e1 2 0.2
1e1 3 0.8
1e1 4 0.4
1e1 5 0.8
1e1 10 5.8
2e0 1 0.2
2e0 2 0.2
2e0 3 1.4
2e0 4 0.5
2e0 5 1.5
2e0 10 6.2
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.3 0.3 55% 0.2 255%
0 1e8 2.3
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.3 0.3 55% 0.2 255%
0 1e8 2.3
1 1e7 0.1 0.1 0% 0.1 -4%
1 1e8 2.4

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 2.1 2.1 1%
2 0.2 0.2 0%
3 0.8 0.8 0%
4 0.2 0.2 0%
5 2.2 2.2 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.1 1.1 0%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1.1 1.1 0%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1.1 1.1 0%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 2.1 2.1 1%
2 1e7 0.2 0.2 0%
3 1e7 0.8 0.8 0%
4 1e7 0.2 0.2 0%
5 1e7 2.2 2.2 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 0%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.1 1.1 0%

dask

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 322.8 321.6 0% 305.5 5% 78.5 110%
2 316.6 312.5 0% 332.3 -2% 41.0 235%
3 1979.3 1964.6 3% 1856.9 6%
4 1.0 1.1 -9% 1.0 -5% 0.9 -6%
5 3.9 4.1 -2% 3.9 -5% 3.7 6%
7 69.3 71.1 -4% 70.5 0%
8 1894.6 1902.4 0% 1923.6 -1%
9 28.2
10 13.4 13.9 -3% 14.2 -5% 13.1 1%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7
1e8 544.9 546.2 0% 551.5 1%
1e9 2565.1 2549.2 0% 2444.4 2%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 -4% 0.1 6% 0.1 3%
1 1e8 0.7 0.7 5% 0.7 5% 0.6 17%
1 1e9 967.4 964.1 0% 915.7 5% 234.6 312%
2 1e7 0.2 0.2 1% 0.2 -4% 0.2 13%
2 1e8 1.5 1.6 -1% 1.5 2% 1.4 9%
2 1e9 948.1 935.8 1% 995.3 -4% 121.3 681%
3 1e7 1.7 1.6 1% 1.6 6% 1.3 29%
3 1e8 156.4 144.4 8% 147.0 6% 155.1 0%
3 1e9 5779.9 5747.6 0% 5422.1 6%
4 1e7 0.2 0.2 -11% 0.2 -12% 0.3 -25%
4 1e8 1.7 1.9 -7% 1.7 1% 1.6 11%
5 1e7 0.4 0.4 0% 0.4 -9% 0.3 11%
5 1e8 7.3 7.8 -6% 7.4 0% 7.1 2%
7 1e7 1.4 1.4 -6% 1.3 0%
7 1e8 137.3 140.8 -2% 139.7 -1%
8 1e7 280.4 278.7 0% 284.6 -1%
8 1e8 3508.9 3526.0 0% 3562.7 -1%
9 1e7 28.2
10 1e7 13.4 13.9 -3% 14.2 -5% 13.1 1%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 322.8 321.6 0% 305.5 5% 78.5 110%
1 1e1 335.6 341.1 -1% 328.7 2% 49.3 196%
1 2e0 329.8 330.0 -10% 330.4 -1% 129.3 49%
2 1e2 316.6 312.5 0% 332.3 -2% 41.0 235%
2 1e1 324.1 326.2 -1% 323.3 -1% 15.0 710%
2 2e0 326.2 353.7 -3% 359.8 -4% 46.2 211%
3 1e2 1979.3 1964.6 3% 1856.9 6%
3 1e1 259.9 251.1 -1% 271.5 -3% 234.3 10%
3 2e0 509.3 577.0 -5% 493.7 3% 384.8 48%
4 1e2 1.0 1.1 -9% 1.0 -5% 0.9 -6%
4 1e1 1.0 1.1 -17% 1.0 -6% 0.9 -4%
4 2e0 1.0 1.0 3% 1.0 0% 1.0 5%
5 1e2 3.9 4.1 -2% 3.9 -5% 3.7 6%
5 1e1 14.6 14.4 0% 14.3 -1% 14.5 -3%
5 2e0 33.8 32.7 0% 32.3 4% 36.5 -12%
7 1e2 69.3 71.1 -4% 70.5 0%
7 1e1 242.4 248.9 -3% 256.3 -2%
7 2e0 491.9 532.0 -9% 480.8 1%
8 1e2 1894.6 1902.4 0% 1923.6 -1%
8 1e1 2461.0 2665.1 -7% 2572.9 -4%
9 1e2 28.2
9 1e1 4.6
9 2e0 31.6
10 1e2 13.4 13.9 -3% 14.2 -5% 13.1 1%
10 1e1 27.3
10 2e0 865.2
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7
1e2 1e8 544.9 546.2 0% 551.5 1%
1e2 1e9 2565.1 2549.2 0% 2444.4 2%
1e1 1e7
1e1 1e8 167.6 166.5 -1% 175.9 -1%
1e1 1e9 988.5 999.8 -1% 977.0 1% 95.4 1353%
2e0 1e7
2e0 1e8
2e0 1e9 983.1 1024.5 -3% 1034.3 -4% 262.3 383%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 322.8 321.6 0% 305.5 5% 78.5 110%
1e2 2 316.6 312.5 0% 332.3 -2% 41.0 235%
1e2 3 1979.3 1964.6 3% 1856.9 6%
1e2 4 1.0 1.1 -9% 1.0 -5% 0.9 -6%
1e2 5 3.9 4.1 -2% 3.9 -5% 3.7 6%
1e2 7 69.3 71.1 -4% 70.5 0%
1e2 8 1894.6 1902.4 0% 1923.6 -1%
1e2 9 28.2
1e2 10 13.4 13.9 -3% 14.2 -5% 13.1 1%
1e1 1 335.6 341.1 -1% 328.7 2% 49.3 196%
1e1 2 324.1 326.2 -1% 323.3 -1% 15.0 710%
1e1 3 259.9 251.1 -1% 271.5 -3% 234.3 10%
1e1 4 1.0 1.1 -17% 1.0 -6% 0.9 -4%
1e1 5 14.6 14.4 0% 14.3 -1% 14.5 -3%
1e1 7 242.4 248.9 -3% 256.3 -2%
1e1 8 2461.0 2665.1 -7% 2572.9 -4%
1e1 9 4.6
1e1 10 27.3
2e0 1 329.8 330.0 -10% 330.4 -1% 129.3 49%
2e0 2 326.2 353.7 -3% 359.8 -4% 46.2 211%
2e0 3 509.3 577.0 -5% 493.7 3% 384.8 48%
2e0 4 1.0 1.0 3% 1.0 0% 1.0 5%
2e0 5 33.8 32.7 0% 32.3 4% 36.5 -12%
2e0 7 491.9 532.0 -9% 480.8 1%
2e0 9 31.6
2e0 10 865.2
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8 544.9 546.2 0% 551.5 1%
0 1e9 2565.1 2549.2 0% 2444.4 2%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7
0 1e8 544.9 546.2 0% 551.5 1%
0 1e9 2565.1 2549.2 0% 2444.4 2%
1 1e7
1 1e8 563.9 550.8 -3% 556.1 -1%
1 1e9 2620.5 2480.4 2% 2519.8 1%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 111.1 107.6 2% 131.7 -5%
2 120.9 113.2 5% 136.8 -3%
3 119.5 106.5 8% 128.2 0%
4 135.9 142.9 -1% 160.9 -6%
5 217.6 219.0 0% 210.4 3%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 57.7 57.6 2% 55.6 5%
1e8 225.9 217.9 4% 261.9 -13%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 132.5 128.8 3% 147.3 -3%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 132.5 128.8 3% 147.3 -3%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 16.6 16.2 2% 15.7 5%
1 1e8 205.6 199.1 3% 247.7 -17%
2 1e7 17.7 17.2 3% 16.8 5%
2 1e8 224.1 209.3 7% 256.8 -12%
3 1e7 16.2 15.5 4% 15.1 7%
3 1e8 222.7 197.6 12% 241.2 -7%
4 1e7 20.5 20.2 1% 19.8 3%
4 1e8 251.3 265.6 -5% 302.1 -16%
5 1e7 217.6 219.0 0% 210.4 3%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 57.7 57.6 2% 55.6 5%
0 1e8 225.9 217.9 4% 261.9 -13%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 57.7 57.6 2% 55.6 5%
0 1e8 225.9 217.9 4% 261.9 -13%

juliadf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 14.2 14.7 -1% 31.8 -21%
2 19.6 20.2 0% 22.8 -4%
3 131.9 132.0 0%
4 18.9 17.8 2%
5 155.4 153.4 1%
6 71.3 69.1 2%
7 141.8 141.4 0%
8 165.3 167.3 0%
9 93.6 88.5 2%
10 18.5 18.4 0% 20.7 -6% 26.5 -21%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.2 2.2 1% 2.2 -2%
1e8 15.5 15.5 0% 16.1 -1%
1e9 255.0 252.6 0%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 85.3 84.5 0%
1e1 12.8 12.8 -1% 12.6 0%
2e0 19.3 19.0 0% 19.1 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 85.3 84.5 0%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 85.3 84.5 0%
1 70.0 71.1 -1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 5.8 5.7 2% 5.2 12% 4.6 25%
1 1e8 6.9 6.9 0% 6.4 7% 9.6 -28%
1 1e9 29.8 31.6 -5% 81.1 -63%
2 1e7 0.6 0.6 -1% 0.6 -3% 0.6 5%
2 1e8 4.7 4.6 2% 4.7 0% 4.8 -2%
2 1e9 53.6 55.6 -3% 63.1 -14%
3 1e7 1.8 1.8 0% 2.4 -22% 2.7 -32%
3 1e8 15.2 15.2 0% 16.0 -4% 39.7 -61%
3 1e9 378.6 379.1 0%
4 1e7 1.1 1.1 2% 1.1 -2% 1.0 5%
4 1e8 4.3 4.3 -1% 4.4 -2% 6.1 -30%
4 1e9 51.4 48.0 7%
5 1e7 1.2 1.1 6% 1.1 5% 1.5 -17%
5 1e8 19.4 19.9 -2% 20.0 -2% 24.0 -19%
5 1e9 445.5 439.3 1%
6 1e7 2.3 2.3 0% 2.4 -4%
6 1e8 15.0 14.4 3% 14.7 1%
6 1e9 196.5 190.7 3%
7 1e7 1.6 1.6 0% 1.7 -5%
7 1e8 16.9 16.6 2% 16.7 1%
7 1e9 407.0 406.0 0%
8 1e7 2.0 2.0 0% 2.1 -4%
8 1e8 23.1 23.4 -1% 23.1 0%
8 1e9 470.7 476.6 -1%
9 1e7 2.2 2.2 0% 2.2 0% 4.2 -47%
9 1e8 16.3 16.2 1% 16.5 0% 35.6 -54%
9 1e9 262.2 247.0 6%
10 1e7 3.3 3.3 0% 3.4 -2% 3.8 -11%
10 1e8 33.7 33.4 0% 38.0 -11% 49.2 -31%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 14.2 14.7 -1% 31.8 -21%
1 1e1 6.6 6.8 -3% 6.1 9% 13.1 -22%
1 2e0 8.3 8.2 0% 7.6 9% 26.4 -34%
2 1e2 19.6 20.2 0% 22.8 -4%
2 1e1 1.1 1.1 0% 1.1 0% 1.7 -26%
2 2e0 1.1 1.1 -5% 1.1 -5% 2.3 -46%
3 1e2 131.9 132.0 0%
3 1e1 17.9 18.2 -1% 18.7 -8% 48.8 -58%
3 2e0 26.5 26.2 0% 26.9 -5% 58.9 -55%
4 1e2 18.9 17.8 2%
4 1e1 2.8 2.9 -3% 2.9 -1% 6.0 -44%
4 2e0 4.0 3.7 4% 3.7 3% 11.1 -59%
5 1e2 155.4 153.4 1%
5 1e1 16.7 17.1 -2% 16.7 -1% 39.6 -44%
5 2e0 21.7 21.4 0% 21.8 0% 57.0 -60%
6 1e2 71.3 69.1 2%
6 1e1 6.1 6.3 -4% 6.1 0%
6 2e0 7.9 7.8 0% 7.9 0%
7 1e2 141.8 141.4 0%
7 1e1 18.6 18.6 -2% 18.7 -2%
7 2e0 30.9 30.1 1% 31.1 -2%
8 1e2 165.3 167.3 0%
8 1e1 24.1 24.4 -2% 24.0 0%
8 2e0 52.1 50.4 1% 50.6 1%
9 1e2 93.6 88.5 2%
9 1e1 6.8 6.8 -1% 6.6 2% 46.4 -76%
9 2e0 6.8 6.8 -2% 6.7 -1% 117.8 -87%
10 1e2 18.5 18.4 0% 20.7 -6% 26.5 -21%
10 1e1 27.7 25.8 3% 25.4 4% 45.5 -40%
10 2e0 33.8 34.0 -1% 33.8 0% 68.0 -50%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.2 2.2 1% 2.2 -2%
1e2 1e8 15.5 15.5 0% 16.1 -1%
1e2 1e9 255.0 252.6 0%
1e1 1e7 2.6 2.7 -3% 2.6 -1%
1e1 1e8 23.1 22.9 0% 22.6 1%
2e0 1e7 3.9 3.9 -2% 3.9 -2%
2e0 1e8 34.7 34.0 1% 34.3 1%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 14.2 14.7 -1% 31.8 -21%
1e2 2 19.6 20.2 0% 22.8 -4%
1e2 3 131.9 132.0 0%
1e2 4 18.9 17.8 2%
1e2 5 155.4 153.4 1%
1e2 6 71.3 69.1 2%
1e2 7 141.8 141.4 0%
1e2 8 165.3 167.3 0%
1e2 9 93.6 88.5 2%
1e2 10 18.5 18.4 0% 20.7 -6% 26.5 -21%
1e1 1 6.6 6.8 -3% 6.1 9% 13.1 -22%
1e1 2 1.1 1.1 0% 1.1 0% 1.7 -26%
1e1 3 17.9 18.2 -1% 18.7 -8% 48.8 -58%
1e1 4 2.8 2.9 -3% 2.9 -1% 6.0 -44%
1e1 5 16.7 17.1 -2% 16.7 -1% 39.6 -44%
1e1 6 6.1 6.3 -4% 6.1 0%
1e1 7 18.6 18.6 -2% 18.7 -2%
1e1 8 24.1 24.4 -2% 24.0 0%
1e1 9 6.8 6.8 -1% 6.6 2% 46.4 -76%
1e1 10 27.7 25.8 3% 25.4 4% 45.5 -40%
2e0 1 8.3 8.2 0% 7.6 9% 26.4 -34%
2e0 2 1.1 1.1 -5% 1.1 -5% 2.3 -46%
2e0 3 26.5 26.2 0% 26.9 -5% 58.9 -55%
2e0 4 4.0 3.7 4% 3.7 3% 11.1 -59%
2e0 5 21.7 21.4 0% 21.8 0% 57.0 -60%
2e0 6 7.9 7.8 0% 7.9 0%
2e0 7 30.9 30.1 1% 31.1 -2%
2e0 8 52.1 50.4 1% 50.6 1%
2e0 9 6.8 6.8 -2% 6.7 -1% 117.8 -87%
2e0 10 33.8 34.0 -1% 33.8 0% 68.0 -50%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.2 2.2 1% 2.2 -2%
0 1e8 15.5 15.5 0% 16.1 -1%
0 1e9 255.0 252.6 0%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.2 2.2 1% 2.2 -2%
0 1e8 15.5 15.5 0% 16.1 -1%
0 1e9 255.0 252.6 0%
1 1e7 2.1 2.0 2% 2.0 1%
1 1e8 14.9 15.1 -1% 14.8 0%
1 1e9 206.8 210.0 -5%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 203.2 200.1 1% 196.6 0%
2 218.0 215.0 1% 210.4 0%
3 265.7 266.8 0% 257.9 1%
4 220.6 218.9 1% 220.6 0%
5 434.8 432.9 1% 426.8 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 26.9 26.4 1% 27.1 -1%
1e8 510.0 507.1 0% 497.8 2%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 268.5 266.7 1% 262.4 0%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 268.5 266.7 1% 262.4 0%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 24.7 24.5 1% 25.5 -3%
1 1e8 381.8 375.8 1% 367.7 3%
2 1e7 20.7 20.5 1% 21.2 -2%
2 1e8 415.2 409.4 1% 399.6 3%
3 1e7 30.4 29.8 2% 30.5 0%
3 1e8 501.0 503.9 0% 485.2 3%
4 1e7 20.1 19.6 2% 20.1 0%
4 1e8 421.1 418.2 0% 421.2 0%
5 1e7 38.5 37.6 2% 38.3 0%
5 1e8 831.1 828.2 0% 815.3 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 26.9 26.4 1% 27.1 -1%
0 1e8 510.0 507.1 0% 497.8 2%
Sortedness
by NA fraction Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 26.9 26.4 1% 27.1 -1%
0 1e8 510.0 507.1 0% 497.8 2%

clickhouse

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 31.1 27.3 59% 29.5 71%
2 10.9 8.9 8% 8.4 19%
3 36.8 42.0 4% 31.3 -4%
4 22.8 22.6 3% 25.9 -1%
5 14.3 13.8 5% 13.7 6%
6 12.8 11.6 24% 14.1 42%
7 15.2 8.7 31% 14.9 -5%
8 42.8 34.1 9% 46.1 -2%
9 17.5 26.6 -3% 59.0 -15%
10 9.8 9.9 0% 9.8 -2%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.4 0.4 15% 0.4 33%
1e8 3.4 3.1 16% 3.3 3%
1e9 66.1 63.5 11% 79.1 -4%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 21.8 20.9 14% 25.8 11%
1e1 17.4 21.2 -2% 18.3 -3%
2e0 23.5
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.8 20.9 14% 25.8 11%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.8 20.9 14% 25.8 11%
1 9.0 8.4 16% 13.1 -9%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.2 0.1 152% 0.1 211%
1 1e8 0.3 0.3 12% 0.3 -3%
1 1e9 92.7 81.6 13% 88.2 5%
2 1e7 0.1 0.2 -13% 0.1 19%
2 1e8 1.1 0.9 15% 1.0 8%
2 1e9 31.6 25.6 23% 24.2 30%
3 1e7 0.1 0.1 2% 0.2 -14%
3 1e8 1.4 1.1 24% 1.6 -15%
3 1e9 109.0 124.7 -12% 92.0 18%
4 1e7 0.0 0.0 5% 0.0 17%
4 1e8 0.2 0.2 5% 0.3 -8%
4 1e9 68.0 67.4 0% 77.5 -12%
5 1e7 0.1 0.1 3% 0.1 13%
5 1e8 1.1 1.0 7% 1.1 2%
5 1e9 41.7 40.2 3% 40.0 4%
6 1e7 0.2 0.2 -12% 0.1 57%
6 1e8 1.9 1.1 75% 1.0 81%
6 1e9 36.4 33.5 8% 41.1 -11%
7 1e7 0.2 0.2 4% 0.2 10%
7 1e8 1.2 1.1 10% 1.7 -30%
7 1e9 44.1 24.8 77% 43.0 2%
8 1e7 0.8 0.9 -9% 0.8 0%
8 1e8 7.6 6.8 11% 7.5 1%
8 1e9 119.9 94.5 26% 130.0 -7%
9 1e7 0.2 0.1 20% 0.1 26%
9 1e8 1.0 1.0 3% 1.1 -2%
9 1e9 51.3 78.8 -34% 175.8 -70%
10 1e7 1.8 1.8 0% 1.9 -5%
10 1e8 17.8 17.9 0% 17.6 1%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 31.1 27.3 59% 29.5 71%
1 1e1 0.8 13.0 -18% 1.0 -21%
1 2e0 0.8 0.8 7% 1.6 -30%
2 1e2 10.9 8.9 8% 8.4 19%
2 1e1 4.1 5.8 -2% 4.2 5%
2 2e0 4.2 3.5 4% 4.0 -4%
3 1e2 36.8 42.0 4% 31.3 -4%
3 1e1 26.4 28.3 -1% 35.0 -17%
3 2e0 40.7 38.9 8% 54.3 -10%
4 1e2 22.8 22.6 3% 25.9 -1%
4 1e1 15.5 16.1 0% 15.2 0%
4 2e0 20.5 30.4 286%
5 1e2 14.3 13.8 5% 13.7 6%
5 1e1 18.8 20.1 8% 19.3 9%
5 2e0 26.3 26.6 -1%
6 1e2 12.8 11.6 24% 14.1 42%
6 1e1 9.6 15.3 -6% 10.3 -3%
6 2e0 8.7 12.6 4%
7 1e2 15.2 8.7 31% 14.9 -5%
7 1e1 19.9 29.0 -5% 23.0 -13%
7 2e0 26.2 48.9 -19%
8 1e2 42.8 34.1 9% 46.1 -2%
8 1e1 38.3 41.4 0% 32.6 6%
8 2e0 35.6
9 1e2 17.5 26.6 -3% 59.0 -15%
9 1e1 28.3 29.1 0% 29.2 -1%
9 2e0 24.2
10 1e2 9.8 9.9 0% 9.8 -2%
10 1e1 9.9 9.9 7% 10.0 5%
10 2e0 9.3 8.7 9% 9.5 3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.4 0.4 15% 0.4 33%
1e2 1e8 3.4 3.1 16% 3.3 3%
1e2 1e9 66.1 63.5 11% 79.1 -4%
1e1 1e7 0.4 0.3 9% 0.3 -4%
1e1 1e8 3.5 3.4 6% 3.6 0%
1e1 1e9 51.8 64.1 -25% 54.5 -6%
2e0 1e7 0.5 0.4 5% 0.5 0%
2e0 1e8 4.5 4.3 87% 4.5 91%
2e0 1e9 70.4
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 31.1 27.3 59% 29.5 71%
1e2 2 10.9 8.9 8% 8.4 19%
1e2 3 36.8 42.0 4% 31.3 -4%
1e2 4 22.8 22.6 3% 25.9 -1%
1e2 5 14.3 13.8 5% 13.7 6%
1e2 6 12.8 11.6 24% 14.1 42%
1e2 7 15.2 8.7 31% 14.9 -5%
1e2 8 42.8 34.1 9% 46.1 -2%
1e2 9 17.5 26.6 -3% 59.0 -15%
1e2 10 9.8 9.9 0% 9.8 -2%
1e1 1 0.8 13.0 -18% 1.0 -21%
1e1 2 4.1 5.8 -2% 4.2 5%
1e1 3 26.4 28.3 -1% 35.0 -17%
1e1 4 15.5 16.1 0% 15.2 0%
1e1 5 18.8 20.1 8% 19.3 9%
1e1 6 9.6 15.3 -6% 10.3 -3%
1e1 7 19.9 29.0 -5% 23.0 -13%
1e1 8 38.3 41.4 0% 32.6 6%
1e1 9 28.3 29.1 0% 29.2 -1%
1e1 10 9.9 9.9 7% 10.0 5%
2e0 1 0.8 0.8 7% 1.6 -30%
2e0 2 4.2 3.5 4% 4.0 -4%
2e0 3 40.7 38.9 8% 54.3 -10%
2e0 4 20.5 30.4 286%
2e0 5 26.3 26.6 -1%
2e0 6 8.7 12.6 4%
2e0 7 26.2 48.9 -19%
2e0 8 35.6
2e0 9 24.2
2e0 10 9.3 8.7 9% 9.5 3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.4 0.4 15% 0.4 33%
0 1e8 3.4 3.1 16% 3.3 3%
0 1e9 66.1 63.5 11% 79.1 -4%
Sortedness
by NA fraction Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.4 0.4 15% 0.4 33%
0 1e8 3.4 3.1 16% 3.3 3%
0 1e9 66.1 63.5 11% 79.1 -4%
1 1e7 0.3 0.3 -4% 0.3 -6%
1 1e8 3.2 3.1 7% 3.5 0%
1 1e9 24.9 23.1 49% 37.9 -23%

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings

Report was generated on: 2020-04-22 21:36:48 PDT.